|
|
Data collection from sensor units
Frkal, Pavel ; Verner, Lukáš (referee) ; Komosný, Dan (advisor)
This thesis deals with data collection from sensor units connected via 6LoWPAN standard (IEEE 802.15.4 standard), which uses simplified IPv6 protocol on the network layer. Featuring optimization makes this solution suitable for use in systems powered with chemical power supplies with a very low current consumption of both the sensor units and the control units. The thesis focuses on collecting data from sensor units that communicate on a star topology basis but it's also discussed possible usage of general topology, the end-station in such case works as active repeater and thus extend sensor network coverage without need of additional devices for wireless frames repeating or forwarding. It evaluates the realization of sensor networks created by both the actual data collection as well as specific technical parameters of used sensor boards. The practical part contains a specific application for gathering data from sensors present on the units and storing them in a relational database MySQL.
|
|
|
Completion and Optimization of a Temporal Extension for PostgreSQL
Koroncziová, Dominika ; Bartík, Vladimír (referee) ; Rychlý, Marek (advisor)
This thesis focuses on a implemenation of a a temporal data support within traditional relational environment of PostgreSQL system. I pick up on Radek Jelínek's thesis and an extension developed by him. I've analyzed the extension from functional, practical and performance perspectives. Based on my results, I've designed and implemented changes to the original extension. The work also contains implementation details as well as performance comparison results between the new and the original extensions.
|
|
|
Information System for Registration and Management of Corporate Orders
Paľko, Matúš ; Janoušek, Vladimír (referee) ; Kočí, Radek (advisor)
This thesis aims to design and implement an information system for the company SGS Zvolen s.r.o., according to customer requirements. It's used to register and manage information about the workflow of corporate orders. It takes the form of a web application developed on the Laravel framework connected to a MySQL relational database. The thesis also deals with user interface design and communication with the customer regarding the design of the system. Only a part of this extensive system was created, which was tested by the customer.
|
|
|
A Tool for Database Content Analysis for Testing Purposes
Želiar, Dušan ; Češka, Milan (referee) ; Smrčka, Aleš (advisor)
The aim of this bachelor's thesis is to create a tool for generating database content for testing purposes. The main function of the generator is to create random data which meets defined constraints. Constraints describe structural relationships in a database as well as semantic dependencies among columns in tables. The result of the thesis is a tool which generates test and inserts data into database based on defined constraints. The last part of the thesis contains demonstration of the functionality on a real database.
|
|
|
XML Persistence in Relational Databases
Boháč, Martin ; Kolář, Dušan (referee) ; Chmelař, Petr (advisor)
The aim of this thesis is to create a client xDB database, which supports visualization and management of XML documents and schemas. The first part deals with the introduction of XML, XML schemas (DTD, XML Schema, RelaxNG, etc.) and contextual technologies. After that the thesis deals with the problem of the XML persistence and it focuses on mapping techniques necessary for an efficient storage in a relational database. The main part is devoted to the design and implementation of client application XML Admin, which is programmed in Java. The application uses the XML:DB interface to communicate with the xDB database. It supports storing XML documents to a collection and the XPath language for querying them. The final section is devoted to application performance testing and comparison with existing native database eXist.
|
|
|
Information System for Registration and Management of Corporate Orders
Paľko, Matúš ; Janoušek, Vladimír (referee) ; Kočí, Radek (advisor)
This thesis aims to design and implement an information system for the company SGS Zvolen s.r.o., according to customer requirements. It's used to register and manage information about the workflow of corporate orders. It takes the form of a web application developed on the Laravel framework connected to a MySQL relational database. The thesis also deals with user interface design and communication with the customer regarding the design of the system. Only a part of this extensive system was created, which was tested by the customer.
|
|
|
A Tool for Database Content Analysis for Testing Purposes
Želiar, Dušan ; Češka, Milan (referee) ; Smrčka, Aleš (advisor)
The aim of this bachelor's thesis is to create a tool for generating database content for testing purposes. The main function of the generator is to create random data which meets defined constraints. Constraints describe structural relationships in a database as well as semantic dependencies among columns in tables. The result of the thesis is a tool which generates test and inserts data into database based on defined constraints. The last part of the thesis contains demonstration of the functionality on a real database.
|
|
|
Completion and Optimization of a Temporal Extension for PostgreSQL
Koroncziová, Dominika ; Bartík, Vladimír (referee) ; Rychlý, Marek (advisor)
This thesis focuses on a implemenation of a a temporal data support within traditional relational environment of PostgreSQL system. I pick up on Radek Jelínek's thesis and an extension developed by him. I've analyzed the extension from functional, practical and performance perspectives. Based on my results, I've designed and implemented changes to the original extension. The work also contains implementation details as well as performance comparison results between the new and the original extensions.
|
|
|
Data collection from sensor units
Frkal, Pavel ; Verner, Lukáš (referee) ; Komosný, Dan (advisor)
This thesis deals with data collection from sensor units connected via 6LoWPAN standard (IEEE 802.15.4 standard), which uses simplified IPv6 protocol on the network layer. Featuring optimization makes this solution suitable for use in systems powered with chemical power supplies with a very low current consumption of both the sensor units and the control units. The thesis focuses on collecting data from sensor units that communicate on a star topology basis but it's also discussed possible usage of general topology, the end-station in such case works as active repeater and thus extend sensor network coverage without need of additional devices for wireless frames repeating or forwarding. It evaluates the realization of sensor networks created by both the actual data collection as well as specific technical parameters of used sensor boards. The practical part contains a specific application for gathering data from sensors present on the units and storing them in a relational database MySQL.
|
|
|
XML Persistence in Relational Databases
Boháč, Martin ; Kolář, Dušan (referee) ; Chmelař, Petr (advisor)
The aim of this thesis is to create a client xDB database, which supports visualization and management of XML documents and schemas. The first part deals with the introduction of XML, XML schemas (DTD, XML Schema, RelaxNG, etc.) and contextual technologies. After that the thesis deals with the problem of the XML persistence and it focuses on mapping techniques necessary for an efficient storage in a relational database. The main part is devoted to the design and implementation of client application XML Admin, which is programmed in Java. The application uses the XML:DB interface to communicate with the xDB database. It supports storing XML documents to a collection and the XPath language for querying them. The final section is devoted to application performance testing and comparison with existing native database eXist.
|
guest ::
